ZINC 12

User Information

Page Size:

Format: Overview Compact Basic Summary Targets List Properties Purchasing Info Catalog Info SDF CAS SMILES MOL2 Flexibase ZINC Names Names+Smiles 800lb Gorilla MOL2 (e.g. PyMol) SDF (e.g. Chimera) SMILES (e.g. Marvin) Gorilla (e.g. Instant JChem) Representations: Default All Single Usual Metals Reference Mid High Low Purchasability: Purchasable In Stock or On Demand In Stock Only Make On Demand Boutique Not For Sale Annotated Model Systems Collabocules Everything Boutique (at any price)

Well this is embarrassing

If you believe there should have been a result, please tell us what you think is missing. (Vendor ID, Compound ID, URL to where we can find the molecule on line). Thanks!

Parameters Provided:

name.synonym = ( /-)-2-(Chloromethyl)oxirane;( /-)-epichlorohydrin;(chloromethyl)-Oxirane;(chloromethyl)-oxirane;(chloromethyl)ethylene oxide;(DL)-alpha-epichlorohydrin;(RS)-3-Chloro-1,2-epoxypropane;1,2-Epoxy-3-chloropropane;1-Chloro-2,3-epoxy propone;1-Chloro-2,3-epox
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '( /-)-2-(Chloromethyl)oxirane;( /-)-epichlorohydrin;(chloromethyl)-Oxirane;(chloromethyl)-oxirane;(chloromethyl)ethylene oxide;(DL)-alpha-epichlorohydrin;(RS)-3-Chloro-1,2-epoxypropane;1,2-Epoxy-3-chloropropane;1-Chloro-2,3-epoxy propone;1-Chloro-2,3-epox' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=%28+%2F-%29-2-%28Chloromethyl%29oxirane%3B%28+%2F-%29-epichlorohydrin%3B%28chloromethyl%29-Oxirane%3B%28chloromethyl%29-oxirane%3B%28chloromethyl%29ethylene+oxide%3B%28DL%29-alpha-epichlorohydrin%3B%28RS%29-3-Chloro-1%2C2-epoxypropane%3B1%2C2-Epoxy-3-chloropropane%3B1-Chloro-2%2C3-epoxy+propone%3B1-Chloro-2%2C3-epox&filter.purchasability=all

Embed Link to Results

<div id="zinc-link"></div> <script type="text/javascript" src="//zinc12.docking.org/js/embed.js"></script> <script type="text/javascript"> window.zinc.embed('zinc-link', { "name.synonym": "( /-)-2-(Chloromethyl)oxirane;( /-)-epichlorohydrin;(chloromethyl)-Oxirane;(chloromethyl)-oxirane;(chloromethyl)ethylene oxide;(DL)-alpha-epichlorohydrin;(RS)-3-Chloro-1,2-epoxypropane;1,2-Epoxy-3-chloropropane;1-Chloro-2,3-epoxy propone;1-Chloro-2,3-epox" }); </script>